SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 993686 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 993686 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455089,400016,321110,513351,248368,926958,801202,352464,10637,186433,522638,564415,483370,718136,246242,661277,573246,775002,835613,127821,144019,555638,101478,830530,696740,395221,67939,245681,730800,669039,319477,36215,611641,660603,507086,14733,1017845,471270,762295,139840,883518,458897,454888,170457,10607,178100,219608,900390,618157,737307,449140,28883,489936,1039109,264912,570783,278276,391773,963809,735168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 993686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 993686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]