SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508064 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508064 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829531,1027833,745141,902369,376711,161151,609190,260291,247099,133321,4752,183879,994611,598066,701352,605931,785271,710936,788042,299162,236153,491612,889653,105597,50554,968437,890037,647748,702823,37852,961642,521019,388216,136914,106435,653750,21045,791927,991039,418257,268462,439830,355680,651058,941435,854956,683782,738101,648630,127836,168488,482556,58011,90331,1033279,746209,231002,883617,388273,227355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]