SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610520 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610520 [ RunTime:0.001440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258524,232807,242415,415766,986371,438554,498956,608594,886371,1041577,275228,722789,508737,66070,744601,555370,927910,246066,99317,379381,386654,338586,375637,737987,568718,492844,802126,361685,671916,367957,871138,865846,662235,531563,78619,908409,308,1325,982247,735958,412647,688467,25514,26714,501721,334356,539720,216115,1017875,698251,137078,337695,947915,534788,54839,171533,674181,653311,890154,965687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]