SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510412 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510412 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587873,19039,525431,683034,742129,611047,824038,321476,153314,553768,670099,623773,115868,327800,556364,56574,17486,277189,816075,397243,552086,408685,374177,225537,457300,274269,432604,28999,935947,984584,216188,20415,292497,556044,568796,419270,758808,463234,251620,149220,521123,66972,316098,360389,690513,309420,801165,712887,63654,468549,332942,256689,290470,521427,584496,512465,386603,380563,183520,125697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]