SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36498 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36498 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039060,52405,820118,925176,741071,930219,1042500,520833,1017519,146210,351034,128639,222658,24510,528652,718562,838843,892876,635957,106773,71215,234255,464688,696419,581666,688851,656580,454892,878958,547091,520547,557909,558425,315987,589615,369879,930740,556761,626509,11724,212224,200223,293178,86703,194924,330231,543202,275652,843258,136427,932394,696681,802551,723156,435848,743639,757603,497364,778835,638903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]