SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391831 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391831 [ RunTime:0.002591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455981,908196,696038,910200,360709,684736,116556,913771,855824,404742,737188,1027856,251710,840061,645758,314507,298142,916903,868551,588470,975172,1029223,699147,571690,609052,770762,354956,82468,723693,762749,244303,915879,815297,239100,968850,144730,939239,996648,344383,946384,384357,636034,849525,1036858,342288,903606,221083,630041,500077,1041614,964080,697504,499198,29254,10514,160866,653051,159297,977621,38670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]