SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 874300 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 874300 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410853,528656,395747,1033152,275039,521480,465308,670780,85675,14027,1048485,655396,374883,418662,109168,711611,481044,437121,611583,552962,50096,1027925,722322,964479,847986,113236,327591,198550,882171,928231,323464,868959,387101,971017,208962,507650,953658,601325,810073,954148,48839,626554,209457,880351,1010868,184501,413285,170075,296609,22836,256594,758978,754401,346783,751521,610030,24031,137666,37991,689920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 874300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 874300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]