SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 938010 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 938010 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814513,844282,129289,1042763,925877,618168,748843,832371,287291,214149,120144,340944,99366,468859,351222,655757,686619,915908,701493,254314,886565,508731,714618,346151,362525,284835,102194,836570,629581,365883,209326,403877,846648,119054,64855,4047,598606,149363,212698,509155,159513,400598,189231,867357,981965,758549,621631,137252,353806,510511,649624,85642,439659,220748,202095,519088,672331,913669,281115,930314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 938010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 938010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]