SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310823 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310823 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889558,802190,187124,1009351,1002638,910785,339220,998220,517876,299954,162681,994250,327959,642078,890990,287497,110369,885802,256143,990698,293204,740850,482598,317864,77827,697093,868888,374367,369111,234862,264178,325252,234470,382470,734311,843072,389209,554828,715,811737,78329,883394,630388,158135,184237,91273,600031,686332,977883,293843,338173,554095,905836,544368,868186,502649,822099,421167,713211,505403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]