SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431599 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431599 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678750,210651,291631,990759,905244,46905,842406,148082,155651,182141,923265,642165,663686,707594,741070,988209,130650,476170,831265,235553,200912,546118,1001402,512643,230166,494674,85280,780363,2933,873801,53188,988475,626820,120094,682326,494871,619433,1030466,290707,596485,689608,775803,785958,389358,799652,935024,26899,957497,300251,347337,120183,43862,115099,148103,951204,507940,243224,694732,669621,39222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]