SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319022 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319022 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198131,722659,968873,570705,822817,73456,988240,59921,1095,595289,389707,353473,145333,138122,286955,174286,257815,488900,46525,616756,515132,569570,254203,564168,830435,487485,577529,197522,531131,514304,59174,148872,633456,417737,882908,503434,872897,589415,1013526,590557,133358,591599,1002681,251668,40680,534119,162726,1040912,607572,376900,989233,574038,645086,920114,497851,842255,280779,679594,485085,900291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]