SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 179413 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 179413 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541362,426390,582963,356584,596414,795804,48591,969131,139181,729387,787265,38058,540758,67391,878578,668204,850693,378311,663762,378834,425837,11947,325237,572085,453180,631003,91383,74414,407888,342406,358715,556736,788721,33868,419347,305791,940020,1048067,523793,922258,612455,342246,192631,367388,490405,338619,415332,162735,798050,172056,401887,440470,1001335,302181,690421,644522,458926,1043000,14976,402522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 179413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 179413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]