SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102058 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102058 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700458,483421,468957,139738,227172,494503,73629,247289,797982,842247,491624,396816,905056,464938,407135,197490,114680,276220,897613,921024,580325,145709,634042,880620,1005957,782869,843235,244778,697614,1024607,601008,599542,872352,993737,706896,67167,685822,480566,575686,325786,588285,395174,491987,374522,110818,278964,162775,982520,675162,171722,840910,663554,924488,1001369,135769,259062,179372,448196,730653,111431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]