SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517152 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517152 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65002,711401,752363,289278,462180,44095,236866,189539,839687,659841,127797,978015,300939,333514,237828,767780,133736,135351,148569,125655,893070,38394,90714,200663,190540,149459,67091,518400,571476,264101,567366,197438,875754,1044072,278417,286890,674850,398721,403724,374203,482655,1029475,640515,615055,624883,695889,377150,607868,446245,474522,334473,28960,954249,884886,307920,849634,774591,58356,545141,867883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001428s ]