SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329988 LIMIT 1 [ RunTime:0.001222s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329988 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165272,171831,103423,490951,197153,139757,551334,323919,599532,296623,1026149,187582,580847,200700,894576,919290,1002698,292264,848926,437811,799139,379356,746174,46818,452178,509151,205370,67314,309404,817384,615606,890391,195289,698290,63245,263662,299353,808496,639749,576165,820312,538916,470089,867394,339497,389379,334945,427227,554524,69836,696362,480669,398660,614045,166410,550921,1010749,388165,152163,862955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001151s ]