SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581135 LIMIT 1 [ RunTime:0.002180s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581135 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467582,581741,388393,361437,115345,773670,508703,937467,1009384,426934,570222,220980,653822,118902,599140,607562,120725,353947,478112,157466,515865,421824,981908,839537,187988,657324,263322,549704,960029,144195,801898,217601,155638,582325,473453,236058,742075,619846,879911,968853,143538,631571,283251,417387,15166,728333,591908,80752,922711,964672,586401,213203,827071,688896,294942,31683,736713,263678,430470,713033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581135 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581135 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]