SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450132 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450132 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624222,241863,1006173,949087,652305,1016684,113412,139712,129294,980663,40273,489518,951027,783772,295173,304081,152683,20814,489722,132873,565257,574608,846159,207053,539319,803776,253540,513377,510114,833582,1029660,358939,419679,303553,689353,425999,882867,823528,570268,434672,205948,29587,114007,41314,279085,660320,576984,833189,602419,794115,860204,820948,460433,608029,309351,289426,276590,484476,138735,760470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450132 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450132 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]