SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305083 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305083 [ RunTime:0.002277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18843,1011884,1023364,861308,196570,1003418,888940,20496,515831,181267,219162,513773,891723,271136,583540,164338,257485,63881,735609,815961,314534,146231,332769,634485,143328,578104,835371,1033335,169100,589069,759999,523460,347961,58300,452666,855089,113928,1024634,170721,116550,987040,798122,81525,355297,300075,769670,378207,1029934,80723,545703,608853,749699,3697,152394,215805,875435,481268,255485,1030629,411905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]