SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509781 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509781 [ RunTime:0.002595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26583,1004729,702696,2752,202016,414894,805988,101343,814251,1004390,746220,801914,454995,654560,851775,1024663,141316,577340,978332,478306,986268,1028373,660720,671044,488719,1026185,494019,312974,949352,822409,171605,451028,633640,37062,994542,206915,1004895,312498,107149,981020,556144,347536,525172,477528,216259,574272,776350,920118,792021,868773,424213,553102,580679,763396,717489,1014523,1009131,6435,636422,192701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]