SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520326 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520326 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351509,861655,411986,565170,296680,53112,85834,472205,904043,178906,797333,826248,265887,268376,902398,71863,967567,36597,800159,887985,724163,339651,251505,221961,701136,294901,760266,295231,276236,662564,97471,159662,680356,669147,304980,505709,346336,787535,818439,601746,509468,26960,790382,269121,110665,732995,444849,104255,648539,881875,924858,550116,224436,350708,609309,822937,988760,197343,972039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]