SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381014 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381014 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470236,204431,738715,927047,370955,10138,221711,941661,251153,555244,898923,715268,56849,98263,1044061,272953,536952,892520,147990,22924,499417,97097,684467,563231,85383,502620,443427,72087,228731,991430,804782,337784,906505,842447,752106,794720,225878,719287,203303,521664,896021,220128,1043303,889077,814159,876840,912311,308578,467846,389907,929120,46660,996640,761452,906615,606953,395516,54114,924715,177199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001426s ]