SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448141 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448141 [ RunTime:0.002214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489390,196480,289357,395288,675070,208423,827302,890764,672306,667919,708342,321340,390928,1048803,676807,708527,765773,751543,992667,633060,59424,871498,910476,930574,939969,439905,791666,437311,829294,421765,787776,233296,559149,539436,815208,814726,671186,496242,179363,351621,120101,113485,763796,597174,863125,503121,301400,932618,411687,255894,763304,878643,288636,289866,802236,738817,109332,150384,753693,788480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002226s ]