SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986183 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986183 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038905,516449,26274,135377,38927,732198,969403,1027301,485605,642277,530291,707736,165738,437188,335454,649045,693601,608321,446128,86230,739208,1043744,205921,152795,801916,837027,641847,749296,924686,157435,553123,912496,80546,815776,862710,404985,330956,304662,211488,495045,979190,494949,630965,59290,283531,707860,898165,175059,275105,871219,540026,954289,289759,776747,581073,285356,677908,760764,387932,271815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]