SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002551s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422100 LIMIT 1 [ RunTime:0.001151s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422100 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256655,127892,559199,76965,639393,610359,641283,20938,874259,451011,153927,344908,21975,807013,1024433,787446,201822,872394,64849,115807,486928,22748,580084,347015,369930,863547,437141,640934,159022,93062,266267,87363,292690,927273,931008,108923,707426,577148,3455,280072,936959,792074,601390,849709,877030,493670,227023,703288,984384,171898,213174,679103,52979,935307,686273,971618,119422,282863,406196,594684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]