SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318898 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318898 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035030,425425,511375,662700,77015,1020153,988055,920357,375954,958685,368173,816649,158,934048,244022,740507,795992,330433,898878,884724,761271,549441,525633,325817,986219,590461,481979,931651,985401,651350,609197,937152,702052,346818,539084,850912,27080,443778,592071,891191,311014,170074,139576,441394,955264,117434,901951,700153,244981,488934,929077,702285,1003898,507925,69074,78907,5832,588735,229850,786931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]