SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306512 LIMIT 1 [ RunTime:0.002479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306512 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006335,501872,407436,186830,241223,739769,666044,196583,863009,918462,902494,851173,784706,798076,896369,456413,170952,225437,186081,933499,203200,694030,370276,170065,545195,201610,535294,381309,645479,197149,1037123,85211,78001,342280,812195,124027,380889,653651,498140,571874,474173,823558,1010747,343623,752227,594882,27550,150822,442551,56678,777175,193154,971514,1003053,152743,52394,596007,82698,38569,397489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004072s ]