SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570810 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570810 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772494,1001393,309500,786333,792328,475385,990997,899833,109148,26581,841464,737476,1015320,358563,1008923,554507,988299,426914,1039892,316884,985854,282776,560264,762421,574407,25034,733248,181784,612104,782929,814297,257914,330832,33793,972491,722710,406624,309032,796479,743367,207037,751542,389902,37305,408570,946002,719189,355715,881846,238720,929969,392536,1021326,552366,682268,521686,457373,138959,582625,844304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001686s ]