SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315852 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315852 [ RunTime:0.002502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510721,118445,436527,202188,688405,801149,1034784,123450,802867,149879,580981,1019285,881746,660211,543597,879868,692251,253396,600300,103395,657123,955241,373118,845,317093,974775,408887,76755,845373,507957,256788,80913,967189,320695,216305,300830,154568,879611,840411,668936,964168,598392,188043,960615,23227,1001941,252902,793479,634489,94166,741621,977026,739253,601402,113090,524509,238888,636461,920915,1004553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]