SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014608 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014608 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396224,1012446,848626,499317,44255,989614,965037,267234,574979,133711,406602,92281,573386,852874,790502,185549,990618,510583,112131,708023,367863,926013,286716,964004,146229,997297,996409,644277,621413,157288,1021602,198890,612130,315748,768824,745285,623418,827222,492854,531925,511530,324418,677013,41594,983096,70422,92798,170622,272814,397789,159836,804904,265860,900537,105543,486727,204833,607962,450157,353694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]