SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106948 LIMIT 1 [ RunTime:0.002360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106948 [ RunTime:0.004345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798016,663631,940911,759732,680787,330656,398707,432174,546111,614053,411222,551515,542620,818283,818997,706261,973933,880487,838694,471143,910990,830115,315135,539597,904577,144063,635991,204641,712323,1025200,43111,219966,176933,596719,37886,918598,973657,373663,966586,57642,241636,339083,244317,395322,688544,345240,396149,12385,559614,635391,759349,1020544,892136,174675,1047105,734303,908141,582199,611544,644958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]