SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532480 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532480 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573430,35588,440992,634434,837609,906336,4464,758515,584421,663050,539674,912024,679967,282799,10162,495253,468354,720660,520811,210748,968501,332650,960029,219864,310715,234212,584838,250187,312672,913403,631496,679525,620847,973750,38765,510815,736184,372765,101103,726,193074,348723,650729,274969,668775,373641,887208,440047,47035,809542,452460,169884,341446,536902,943848,274619,666015,484664,983694,16934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]