SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249910 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249910 [ RunTime:0.002255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746094,711019,1029391,656013,360824,5244,496609,896439,350989,643009,732297,222929,335116,25695,179781,769497,576777,670837,851751,303522,642831,477701,856601,628190,243540,377863,332125,475261,458352,701066,955825,1034636,845809,575582,608103,75035,584380,1043844,1021600,462602,1033357,504249,782757,679425,394377,312537,332938,302424,263863,601466,71300,555538,555957,69670,334567,637887,478036,780609,441177,750857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]