SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015021 LIMIT 1 [ RunTime:0.001492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015021 [ RunTime:0.002848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865248,778667,635276,166593,654556,187570,161808,274732,646677,509625,306857,905464,80338,986847,733970,384619,286956,842312,604398,394424,660546,13096,608293,545850,115143,603331,569234,689843,746740,71574,831439,349612,1036452,515019,525077,536718,156859,779978,290330,758702,732945,875491,359794,43760,522625,758287,321522,675519,434740,694389,585869,139558,11584,796910,411968,401783,249544,802276,247761,210190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]