SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533654 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533654 [ RunTime:0.003004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235932,911322,833081,248148,170446,1004712,139554,316128,772855,896781,781234,125822,3648,599381,718279,701910,778130,676961,701448,180889,623284,270999,878347,150111,282110,584995,786571,318103,935102,802615,932417,150793,833068,602988,342510,183301,626649,239174,106433,844337,821095,1007397,384142,122563,281175,107175,384403,510157,387934,585907,555214,487691,844368,881380,798104,912552,925609,6421,792391,180724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]