SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406047 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406047 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848080,981549,401336,280412,737979,512240,445729,207070,398692,1039754,19549,411324,652376,218085,163948,407991,503753,853085,1036258,684659,75742,802071,198243,331609,22555,234899,887344,105450,229163,281269,594759,248792,703469,420114,642026,371415,987770,906073,680990,37075,947218,574047,432984,498995,395459,769665,64086,941826,186082,536288,702216,984575,666384,256216,848569,818102,342610,712011,601730,507806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]