SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459580 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459580 [ RunTime:0.004481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743390,97024,871556,1010506,53546,513579,215696,427757,243754,954728,150452,1044593,628692,700836,337148,575808,564389,470656,307167,922330,355896,527700,506142,738806,393762,293297,1042507,564851,778455,385695,361623,925140,963584,43457,903822,131253,747497,792636,825822,722731,942014,569885,860444,954546,608390,994404,510011,856711,735376,928837,1008360,914746,777817,933382,998020,552299,664478,282109,202646,242315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]