SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001626s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105584 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105584 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525840,488981,717467,589566,482114,809875,276675,611212,192751,82695,867573,844047,158719,577501,619330,324853,571015,642516,107013,71328,559200,397900,904124,994184,874345,757549,377403,758238,454394,676026,1018430,998417,720771,249922,716114,931274,985103,611408,114903,1025875,197228,313535,942294,561860,645066,854285,63957,212108,663397,860025,360722,72278,240236,26540,463122,109644,421764,743373,276411,370486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]