SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 721280 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 721280 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217819,277172,201711,388007,360920,551790,820218,511903,843621,256295,187918,224321,253144,735865,542532,1013335,170854,223122,686918,358845,190151,319020,20532,888602,633350,147656,897150,19595,402987,158038,446974,967034,478685,978745,593278,493395,686833,1029394,780612,639196,1037111,522836,443620,839741,738955,803322,40407,903992,649421,549006,297706,448901,581080,960082,246519,1036673,931722,368146,1042309,680526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 721280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 721280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]