SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 181311 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 181311 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38370,545227,262125,776155,616274,696584,290446,60942,269805,421147,693721,637260,117126,292606,459621,1042476,131225,570328,222687,810358,692587,886155,297217,32583,383227,433688,55113,557190,24520,396657,950516,760651,740835,629263,754390,961677,979205,343164,252084,655209,101556,846998,64343,441202,714039,236561,200352,787396,889622,930252,54295,251967,463205,517642,788969,354043,663559,154052,649905,250283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 181311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 181311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]