SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547281 LIMIT 1 [ RunTime:0.000590s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547281 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314805,845325,305808,10108,825919,71785,804223,1007667,410124,877095,522732,648581,476329,876138,360122,372080,249566,167018,126349,896916,532503,1017067,670396,595222,533921,213346,389991,432422,933108,140012,311983,841547,924579,801148,976642,786757,794783,1029616,1018067,262896,338063,733542,318130,128091,428764,578394,533018,608995,610384,71682,925933,198564,529280,669075,12142,66393,159918,843966,934820,712634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]