SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385178 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385178 [ RunTime:0.002961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309820,379814,588962,1047586,499199,965622,564884,432338,423566,4349,825994,816219,886431,652479,60379,908324,810215,429304,39168,475966,828696,15573,656182,85535,410423,134660,576896,489516,120474,923062,514444,555292,663269,901475,934314,352357,467104,834160,775921,283266,120953,192864,673824,297003,33774,907294,372745,402620,351117,83132,902712,487128,158397,106591,68459,93291,607517,252154,239644,170239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]