SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453417 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453417 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106096,186063,518802,607561,246466,71004,947219,549408,195121,677704,276329,437435,872888,683035,1008353,330888,430449,241863,814684,374186,538716,483743,509772,590297,343277,209624,365559,915115,107815,735755,1000965,147932,701847,712061,27254,524595,182348,519893,143143,182247,752711,409013,307133,332095,948767,143968,621447,767356,122817,269416,229446,526080,639196,752642,1014116,193713,867466,541669,757697,125709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]