SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577831 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577831 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312591,354545,318817,484681,862425,26588,414021,26127,439542,836438,840753,587212,1013644,181485,467740,524403,496653,202084,1019229,468765,471353,890111,377420,745926,219668,917146,938870,723673,708838,908281,673158,910912,374798,732908,461806,528948,1010756,982454,79812,1042643,1019644,196308,798723,126587,556709,935341,12712,245771,923505,766380,75278,374850,37304,774880,800572,998180,607998,95841,1019704,890196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]