SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018288 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018288 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41384,884907,587217,551479,986161,648528,227670,623271,2985,891667,13742,1026030,713351,783792,313594,573378,50167,475479,257834,115912,316422,340421,449768,511852,709765,412369,836924,817506,88654,762615,12051,852093,556242,758359,806617,940159,955697,1007595,52429,222812,648542,226881,494017,100651,511349,556983,630831,239170,511142,741617,884323,491813,65548,571498,529407,77100,662828,90402,773274,494615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]