SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141949 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141949 [ RunTime:0.003616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519019,327209,1023585,466140,1044193,243987,984656,425890,351820,1001021,943043,271070,683010,550744,243891,373067,392939,94464,491891,380960,520266,577938,553567,141293,297636,481275,790576,23341,981999,410414,699738,7916,448713,602440,706549,712633,833635,639272,160131,564576,965000,926147,584005,554353,108700,155347,935357,336553,199456,997761,656740,571337,382685,837904,26308,978057,872460,188107,111880,859296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141949 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141949 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]