SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842004 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842004 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972215,45798,166089,421300,1031250,377907,531109,117694,346129,469571,240694,276743,30036,684204,601705,350072,362912,80898,928655,972856,671135,645760,518171,791588,805627,618198,763841,732004,872124,67315,105967,286105,744907,828657,809452,892248,577053,978760,940990,761788,241800,314699,1041746,321956,339215,876515,137764,326712,834627,384543,803496,80915,948485,901526,332355,128547,121924,20602,345781,411526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]