SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 673900 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 673900 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58042,401041,322580,590245,399329,130444,317436,723536,683542,551458,136216,453026,68297,314220,1047763,942867,1028913,875485,859809,90928,678993,484136,380619,101336,543302,526587,114939,117826,351017,346835,741550,582105,425251,303131,274866,459715,930994,805175,229527,82105,246623,879135,421958,243793,243518,1015995,311713,449126,189636,365915,243046,387824,339583,80390,544463,171308,49976,363165,571462,315582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 673900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 673900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]