SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504170 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504170 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819593,518286,1000966,833225,344845,662545,607409,211550,233125,785272,669562,556387,808630,532693,344446,711216,498034,734206,1011227,242188,787499,512586,846928,590035,996378,66089,617133,886391,849756,841055,129053,868676,76995,79449,797673,677501,953061,568889,547459,656731,690356,971643,659032,364472,665191,767205,330024,270511,705366,132784,633381,1005608,858190,310218,789088,115531,239320,831136,333850,271685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]