SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 763801 LIMIT 1 [ RunTime:0.000519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 763801 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352301,201079,169527,464115,303406,138180,736058,484903,878162,895412,704941,42787,99938,674643,943772,606993,1044998,749260,223393,794369,929619,35718,239035,539786,465575,599979,226779,315161,38928,151382,436299,548999,605356,484049,730330,1032722,722157,786650,325195,699270,630381,46393,571764,823720,38145,639972,1008207,359678,671048,1014156,481668,386542,225106,140849,291417,163956,731501,12412,952663,634458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 763801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 763801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]