SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 918839 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 918839 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614803,450806,1003775,781386,20697,630119,407560,444342,833999,72586,425975,163036,168100,310103,475252,343181,35617,649691,591670,500969,489624,889501,379056,73587,880037,105900,992801,709991,449328,734491,489092,368036,551358,679806,861772,355202,685191,774077,95490,1016340,48836,863135,373516,350108,678524,397207,480401,928795,949223,896057,7115,414600,880499,1035793,138452,837410,801049,737541,246441,889352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 918839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 918839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]