SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525126 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525126 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221045,161509,197302,567559,589072,401236,721972,549550,616851,13074,910133,458885,268741,1005441,769551,260144,837217,57208,264876,63936,976813,366907,154488,1027647,518278,395492,706906,945511,135403,287629,924359,147847,482120,822086,446816,376385,571520,413012,125035,892161,883608,778039,327325,251460,432112,984295,310162,102854,879069,185484,453314,1040133,296804,779510,773494,1011302,748457,304414,366299,537178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]