SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021644 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021644 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88616,154774,793136,932326,405830,427178,419773,296502,351585,835418,840184,198102,752196,709112,524776,927554,802710,389103,846765,646227,990171,32404,937107,211893,681565,381491,1007205,290595,959810,955017,702366,852639,487464,206026,247977,246179,917917,708001,869622,229393,460963,951434,339651,261273,204991,40871,158982,967093,611313,650883,200812,110146,315055,736859,20875,667014,1023700,243080,464891,535488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]