SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190960 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190960 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336676,584816,371299,174341,863075,522445,510651,545468,85456,597838,523691,380949,144098,151175,510951,271332,174928,703802,316644,290028,881575,283940,741960,588691,86946,746554,64311,305316,1012767,356456,456445,58858,204312,346280,535289,216050,456596,186677,262814,844630,1036823,966280,327720,551393,459004,424462,971522,556220,501471,324024,464337,325257,990289,621117,1014726,220526,1040860,217758,883424,834259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]