SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533390 LIMIT 1 [ RunTime:0.001916s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533390 [ RunTime:0.003346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137198,575782,774002,201113,529672,218373,23011,129651,474792,211504,678061,801678,270051,674978,777332,417504,242129,688851,1044229,65762,786539,836027,517606,429370,285589,883819,522926,598946,77344,877672,692008,491220,643462,639985,1048630,259675,900622,731386,1021104,641847,50979,811130,856960,319598,127926,557530,1033513,1016795,31459,177623,966161,455764,536668,248478,230931,1016791,119679,313508,628356,405410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]