SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047104 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047104 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199281,965206,870261,941994,644781,961826,119539,829831,568102,52817,380618,104999,83195,946389,826079,151558,480900,613969,889813,984506,51549,116834,262206,800494,334755,706071,16738,466552,245451,144555,67687,781570,211379,905153,318643,693126,141981,917088,592793,410698,278433,410724,966134,997400,130074,746077,371627,130219,581997,468260,1029351,782796,738290,848464,1025319,370936,924387,631482,909948,405466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]