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` = 1023568 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023568 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694538,606742,499670,752786,278998,437978,159070,369919,534942,133499,669286,24039,754225,333191,20359,904354,930507,113223,1010443,162531,1028459,243655,155748,429007,439858,903251,304866,814216,830327,86380,30520,717588,753089,669102,999519,903644,875269,404745,97602,445984,524291,72933,677938,933643,146452,480362,678083,616042,1012066,285372,833957,379826,322004,932528,468213,209635,628530,312680,393669,384813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]