SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392610 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392610 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685857,911564,872696,823348,258126,224236,393292,144705,301612,540634,554237,845837,529773,734534,444938,653711,272718,860356,496119,563866,127882,410655,555877,326979,228874,295511,298393,903499,834962,92990,921593,950071,297232,722301,814320,195946,569678,312457,291933,294867,676564,524336,377714,724139,348875,700344,721911,379991,890417,907996,412877,823700,30260,283505,912048,222059,215563,1021833,852526,478841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]