SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517860 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517860 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443045,796671,1010990,763761,639827,495252,861813,492045,586363,169298,188088,598101,814910,913154,641790,223333,271037,655515,436195,473311,1025665,1007708,389547,187570,440139,479128,454692,816694,476834,497343,565983,62520,313330,759896,851278,468545,191211,255520,932349,866462,77311,677856,743663,736169,789442,627678,33354,92595,191668,1017552,881250,729332,172152,1027903,692314,820937,688800,683691,166451,403855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]