SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001985s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47678 LIMIT 1 [ RunTime:0.000964s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47678 [ RunTime:0.002117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490952,197340,652065,425101,517875,984160,553217,250710,946624,178247,557620,882929,706500,866956,313290,771009,978390,370984,1010687,260541,399098,941960,434195,645549,493184,769282,956974,325718,235987,779074,74129,432482,776810,495860,72636,723947,516829,1020274,667480,744149,19768,935435,869621,707074,312038,886610,897903,71601,240603,591522,62962,863864,720194,325857,939326,414206,665615,344297,425113,513843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001735s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001144s ]