SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201600 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201600 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037434,230281,757068,468780,819969,606062,778897,645119,449749,242990,730174,593952,131931,488942,528088,818827,564495,547593,977625,125077,846608,8910,210189,705939,989535,778575,1028764,472671,734674,800730,81186,470119,256899,534199,589303,613701,807431,664711,410340,139817,4588,35413,685077,347415,554183,586357,125033,364214,540577,58454,293838,556969,880388,464287,172088,542954,460709,750404,938246,688013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]