SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036134 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036134 [ RunTime:0.002483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654036,774816,1010166,127588,437139,246423,794272,631375,932724,639859,93375,24405,148005,567668,933759,1034101,680445,884578,294904,861636,480210,184794,1042605,1038639,930244,339110,615023,258817,99367,360364,580569,380852,553122,678243,273987,549450,304541,686464,796197,464874,302539,367172,518498,534294,57649,239910,576023,812902,890559,175876,95333,695235,252154,431288,589707,440856,42176,1019418,376412,405876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]