SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53141 LIMIT 1 [ RunTime:0.000895s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53141 [ RunTime:0.002792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383832,16389,978602,476310,372091,837369,24667,788413,122687,779551,356689,518855,25584,650184,836971,675889,265111,827962,929552,607259,713838,89063,815922,937880,33477,588894,626830,750800,992395,876113,15547,459469,458931,448975,957726,539996,621748,206205,975771,493103,926145,268877,626979,345029,69336,503155,805177,464958,622169,500936,359599,171958,60540,579884,121412,540942,268362,343717,770545,324230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001735s ]