SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38010 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38010 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696345,1016680,445348,342709,83271,581964,924064,847797,520372,670288,959815,137533,932795,769461,267965,73443,46140,431506,451521,615667,122720,262224,753531,781461,135975,733532,618695,779249,402465,65111,96514,732031,902317,689630,61770,959183,703798,518561,984958,650767,78708,667487,401777,796693,1000839,497637,411497,450093,707002,607643,645606,955419,801205,141655,98238,258045,593699,363679,673958,632084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]