SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414358 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414358 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869811,998171,753107,860890,196403,1007429,47558,858844,665251,203759,25764,541947,334833,966945,1029892,91640,480963,1011756,118089,628094,700178,80396,629268,170811,762334,753992,669530,701244,91474,727191,1014165,683641,738511,433001,859291,377853,747320,976146,505242,837918,63815,411410,980297,864459,489315,207762,313299,926238,361550,956383,35254,70653,155105,528834,593388,399324,610526,687034,511887,492019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]