SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001909s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401378 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401378 [ RunTime:0.004411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044977,798911,504691,974491,50679,859373,15405,755399,455075,178062,301812,598234,815031,557454,297860,986031,221909,707189,155928,618077,533560,467371,683574,915156,673280,825779,836868,523815,1045697,728891,1002545,442579,984210,940042,39531,944072,788641,753080,276626,814663,430084,579297,603179,809153,605812,671337,592834,354348,510486,671673,6820,599694,364378,363595,694816,260490,233414,148675,488484,213738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]