SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34023 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34023 [ RunTime:0.002217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703022,565987,769091,187403,4579,484961,916663,251677,665977,300529,369750,842467,600342,427116,643586,406974,986108,135592,735110,334689,524682,1044081,169906,261620,598947,262711,996489,896382,535204,578753,480702,162702,1018964,326825,282177,564101,582027,619719,1005164,896419,744240,122603,235441,678669,956399,670957,469332,642383,484123,329886,539725,141211,4895,233353,203308,786446,42141,168321,453131,555655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001576s ]