SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102710 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102710 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18400,244576,652796,231472,784862,188016,582786,449675,495927,783386,278412,307175,443839,473504,161169,581007,643383,424025,470793,317496,258069,219190,718682,6343,1037175,600856,399592,942049,57789,532869,147172,788651,919877,330987,770254,296318,518415,1020038,616734,930170,246531,544662,240547,85702,802440,1039898,875211,826108,479173,163242,601823,952454,343568,640369,61484,17078,382205,125693,698943,265813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]