SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 978111 LIMIT 1 [ RunTime:0.000690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 978111 [ RunTime:0.003203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801205,571476,968803,85645,1009637,625008,128670,984520,80144,595048,268443,840270,312092,443827,407184,550808,510222,700739,798407,198249,693143,572498,1000717,702355,1034412,709187,287602,774833,673835,238405,69138,585354,220154,133563,1009063,629310,127866,694442,785021,625626,292023,638006,254864,987995,76248,279967,1014474,741689,693010,783424,320632,902849,656525,862459,115429,322353,43656,509141,351371,851799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 978111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 978111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]