SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110180 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110180 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812068,978485,340055,961068,70314,167115,819455,716197,607142,404486,5089,810396,805655,287859,968635,473721,544936,1030332,91828,686810,714426,156835,385824,1027840,174943,219539,873277,629857,792294,27629,1031164,678115,12500,994049,368351,125633,1034176,272164,59012,900597,451870,559780,1001591,754380,484464,910122,554529,524184,837211,307636,124880,581965,542028,388307,164685,262193,846755,851284,523892,545521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]